2015-02-20 - 17272 - Spec - ASN Trigger JPN POS - (Craig by 2015-03-18) #JapanSD #JapanABAP

SPECIFICATIONS

17272-Spec- ASN Trigger JPN POS


Purpose

To update the retail flag for the non flagged retail materials to consider for Japan POS extracts.

Admin Info

Purpose
 To update the retail flag for the non flagged retail materials to consider for Japan POS extracts.
Requested By
 Craig Spangler
Spec Created By
 Deepak Yasam
Spec Created Date
 23/02/2015
Spec QA by
 Deepak Yasam
Objects
 ZSD_JPN_RETAIL_FLAG
Document Status
 Completed


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 04
2
 Documentation
 04
3
 Development/ Config
 24(10 hours consumed till now)
4
 Unit test in DEV
 08
5
 Unit test in QUA
 08
6
 Other activity

TOTAL
 48

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

None

Documents

[Attach any document(s) received for the requirement(s)]

None


Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 The requirement is changed to have a program that will flag the unflagged retail materials in the MM.The old price and item extract programs would be run as it is.
 Craig Spangler
 02/24/2015
 NA
2
 Removed the logic from program, which was considering deliveries with goods movement status = C.
 Craig Spangler
 04/01/2015
 NA















Functional Requirement

Purpose/WHY:

The materials from the STO deliveries that are created on given date should be picked and the retail flag is checked in the material master for the unflagged materials.

In Scope:
Only the Japan NL deliveries are considered.
Program is not limited with delivery status.

Out of Scope:

The standard LF ,EL deliveries are not included in the scope.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

Below is the solution to flag the unflagged Japan retail materials.
1.A program should be created below fields as inputs in the selection criteria.
2.The programs should read the NL deliveries with ship to party NEC0620 for the given input date and fetch the materials .
3.The above materials would be filtered and the non retail flagged materials would be flagged by using the BAPI.
4.The output should display the list of materials that are flagged with the product attribute 5 ie., retail flag in the material master.


Test Plan

[List test scenarios/cases to be executed here]

For option 1 :
Test ID
 Test Scenario
 Expected Results
SD001
 Execute the program with sales org 3200 , date (current day -1) ,
directory in the application server as inputs (/usr/sap/NED/RETAIL/Japan/IN/Itemextract.txt), and front end file path,file name as inputs.
 1.The NL PGI'ed deliveries of 0620 plant in the specified date should be considered and the materials from these deliveries should be dispalyed in the file with the requied data.
2.For the unflagged retail materials of the extracted materials , the product attribute 5 (retail) should be checked in the material master.
3.The file should be uploaded into the specified application server directory and display the contents in the file, the extract when opened in Notepad ++ should display CR and LF
4.The file should be saved in the directory with the time stamp as text file and with the prefix 01 in the file name.
5.Download the file to front end with the specified file name and display the contents in the file.
SD002
 Execute the program with sales org 3200 and wrong directory in the application server as inputs (/usr/sap/NEDRETAIL/Japan/IN/Itemextract.txt).
 An error log should be dispalyed saying wrong file path.
SD003
 Execute the program in background with sales org 3200 , date (current day -1) ,
directory in the application server as inputs (/usr/sap/NED/RETAIL/Japan/IN/Itemextract.txt), and front end file path,file name as inputs.
 Two separate files should be saved on the application server in thespecified directory with the below expected results.
1.The NL PGI'ed deliveries of 0620 plant in the specified date should be considered and the materials from these deliveries should be dispalyed in the file with the requied data.
2.For the unflagged retail materials of the extracted materials , the product attribute 5 (retail) should be checked in the material master.
3.The Item extract/Price extract files should be uploaded into the specified application server directory and the contents should be displyed in the file, the extract when opened in Notepad ++ should display CR and LF.
4.The file should be saved in the directory with the time stamp as text file and with the prefix 01 in the file name.

For option 2 :
Test ID
 Test Scenario
 Expected Results
SD001
 Execute the program with sales org 3200 , date (current day -1) as inputs.
 The program should flag the unflagged retail materials in the material master and the output should display the list of materials that are flagged.

Scenarios to be tested after removing the logic to check the Deliveries with goods movement status = C.

Test ID
 Test Scenarios
 Expected Results
SD0-001
 Delivery type - NL,
Ship-to party- NEC0620

Delivery without pick & pgi

Material Retail flag is unchecked.

Input Sorg- 3200 and Delivery creation date (04/02/2015)

Execute the program - ZSD_JPN_RETAIL_FLAG
 Program should be executed and Materials should be Retail flagged
SD-002
 Delivery type - NL,
Ship-to party- NEC0620

Delivery with Picking only

Material Retail flag is unchecked.

Input Sorg- 3200 and Delivery creation date (04/02/2015)

Execute the program - ZSD_JPN_RETAIL_FLAG
 Program should be executed and Materials should be Retail flagged
SD-003
 Delivery type - NL,
Ship-to party- NEC0620

Delivery with pick and pgi

Material Retail flag is unchecked.

Input Sorg- 3200 and Delivery creation date (03/04/2015)

Execute the program - ZSD_JPN_RETAIL_FLAG
 Program should be executed and Materials should be Retail flagged
SD-004
 When no materials are available for retail flag on the specified date.

Input Sorg- 3200 and Delivery creation date (03/04/2015)

Execute the program - ZSD_JPN_RETAIL_FLAG
 Program should be executed and error message should be displayed ' No materials to be retail flagged'

Solution Details


We flagged the materials using BAPI technique.
1. Initially we extract the delivery number from the delivery header table(LIKP) based on the sales organization (3200), Date (Delivery creation) ,Customer number( Ship-to party - NEC0620 ) and delivery type(NL-Replenishment dlv).

2. Finally the material are passed into the delivery item table (LIPS) and extracting list of materials, and using that materials, we are extracting product attribute values (Retail Flag) from Sales data of material master table (MVKE) and update the material where product attribute 5 fields is initial using BAPI technique,



Issues

[List Issues / Bugs identified in configuration or development]

The issue is to update the retail flag for the non flagged retail materials.